SaPrintRegBillReportWork

EntityType | Independent
Logical Entity Name | SaPrintRegBillReportWork
Default Table Name | SaPrintRegBillReportWork
Logical Only | NO
Owner | dbo
Definition |
Note |

SaPrintRegBillReportWork Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SaPrintRegBillReportWorkID |  | INTEGER | NO |
BatchId |  | VARCHAR(32) | YES |
RepType |  | CHAR(1) | YES |
SyStudentID |  | INTEGER | YES |
StuNum |  | CHAR(10) | YES |
StudentName |  | VARCHAR(100) | YES |
NameStudent |  | VARCHAR(100) | YES |
StudentAddr |  | VARCHAR(255) | YES |
StudentCity |  | VARCHAR(25) | YES |
StudentState |  | VARCHAR(25) | YES |
StudentZip |  | VARCHAR(25) | YES |
StudentPhone |  | VARCHAR(25) | YES |
SchoolName |  | VARCHAR(75) | YES |
SchAddr |  | VARCHAR(255) | YES |
SchCity |  | VARCHAR(25) | YES |
SchState |  | VARCHAR(25) | YES |
SchZip |  | VARCHAR(25) | YES |
CampusPhone |  | VARCHAR(25) | YES |
AdEnrollID |  | INTEGER | YES |
AdEnrollIDConnect |  | INTEGER | YES |
PrintID |  | VARCHAR(20) | YES |
ProgramVersion |  | VARCHAR(120) | YES |
ExpStartDate |  | DATETIME | YES |
ArBalance |  | MONEY(19, 2) | YES |
ProgramVersionConnect |  | VARCHAR(120) | YES |
GradDate |  | DATETIME | YES |
EstimatedFunding |  | MONEY(19, 2) | YES |
ExpStartDateConnect |  | DATETIME | YES |
Charges |  | MONEY(19, 2) | YES |
PendingCharges |  | MONEY(19, 2) | YES |
GradDateCOnnect |  | DATETIME | YES |
SyCampusID |  | INTEGER | YES |
StudentStatusCode |  | VARCHAR(10) | YES |
StudentStatusDescrip |  | VARCHAR(100) | YES |
PrintOverallBalance |  | BIT | YES |
PrintClassSchedule |  | BIT | YES |
PrintPaymentDueDate |  | BIT | YES |
PaymentDueDate |  | DATETIME | YES |
PrintAddDropDate |  | INTEGER | YES |
AddDropDate |  | DATETIME | YES |
PrintExpFunding |  | BIT | YES |
ExpFundingTermCode |  | VARCHAR(50) | YES |
ExpFundingTerm |  | VARCHAR(100) | YES |
StatementComment |  | VARCHAR(500) | YES |
RegistrationComment |  | VARCHAR(500) | YES |
PrintStudentAddress |  | BIT | YES |
PrintEnrollmentInfo |  | BIT | YES |
Addr1 |  | VARCHAR(255) | YES |
City |  | VARCHAR(25) | YES |
State |  | VARCHAR(25) | YES |
Zip |  | VARCHAR(25) | YES |
Country |  | VARCHAR(50) | YES |
ScheduleAdTermID |  | INTEGER | YES |
Term |  | VARCHAR(100) | YES |
StartDate |  | DATETIME | YES |
AdTermID |  | INTEGER | YES |
BillingMethod |  | VARCHAR(10) | YES |
BillingMethodDescrip |  | VARCHAR(100) | YES |
PrintLedgerCard |  | BIT | YES |
PrintSubsidiary |  | BIT | YES |
AcctStatus |  | VARCHAR(100) | YES |
CreditCardList |  | VARCHAR(500) | YES |
PmtPerDates |  | VARCHAR(100) | YES |
FaStudentAyPaymentPeriodId |  | INTEGER | YES |
TotalAid |  | MONEY(19, 2) | YES |
TotalCharges |  | MONEY(19, 2) | YES |
PmtPerDatesConnect |  | VARCHAR(100) | YES |
AcctStatusConnect |  | VARCHAR(100) | YES |
FaStudentAyPaymentPeriodIdConnect |  | INTEGER | YES |
TotalPayments |  | MONEY(19, 2) | YES |
TotalDiscounts |  | MONEY(19, 2) | YES |
TotalPendingCharges |  | MONEY(19, 2) | YES |
SaBillingStatementBatchStudentID |  | INTEGER | YES |
AdTermList |  | VARCHAR(8000) | YES |
TransDate |  | VARCHAR(50) | YES |
CurrencySymbol |  | VARCHAR(10) | YES |
CurrencySymbolPosition |  | TINYINT | YES |
SySchoolName |  | VARCHAR(255) | YES |
CampusDescrip |  | VARCHAR(100) | YES |
PrintIDonReport |  | VARCHAR(20) | YES |
CampusDescripConnect |  | VARCHAR(100) | YES |
StudentStatusCodeConnect |  | VARCHAR(255) | YES |
StudentStatusDescripConnect |  | VARCHAR(255) | YES |
BillingMethodConnect |  | VARCHAR(255) | YES |
BillingMethodDescripConnect |  | VARCHAR(255) | YES |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
UserId |  | INTEGER | NO |
ts |  | TIMESTAMP/DATE | NO |
FromTransDate |  | CHAR(10) | YES |
ToTransDate |  | CHAR(10) | YES |

SaPrintRegBillReportWork Keys

Key Name | Key Type | Keys
PK__SaPrintR__C72DB0C638115483 | PrimaryKey | SaPrintRegBillReportWorkID

SaPrintRegBillReportWork Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SaPrintRegBillReportWork Check Constraints

Check Constraint Name | CheckConstraint

SaPrintRegBillReportWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SaPrintRegBillReportWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaPrintRegBillReportWork | NO |  |  |

SaPrintRegBillReportWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model

SaPrintRegBillReportWork Data Movement Rules

Name | Type | Rule Text/Value